Microsoft.SharePointLearningKit.Schema Namespace
Classes
Name Description
ActivateLearnerAssignmentRight

Contains constants related to the ActivateLearnerAssignmentRight right.

ActivityAttemptItem

Contains constants related to the ActivityAttemptItem item type.

Each item contains information about one activity in the context of one attempt.

This LearningStore item type is available in both SLK and MLC.

ActivityObjectiveItem

Contains constants related to the ActivityObjectiveItem item type.

Each item contains information about one local objective of one activity within one e-learning package. Objectives that are added to a package by a SCO via the RTE are not included in this table.

This LearningStore item type is available in both SLK and MLC.

ActivityPackageItem

Contains constants related to the ActivityPackageItem item type.

Each item contains information about one activity within one e-learning package.

This LearningStore item type is available in both SLK and MLC.

ActivityPackageItemView

Contains constants related to the ActivityPackageItemView view.

AddPackageReferenceRight

Contains constants related to the AddPackageReferenceRight right.

AssignmentItem

Contains constants related to the AssignmentItem item type.

Each item of this LearningStore item type contains information about one assignment, i.e. one organization of one e-learning package, or one non-e-learning document, assigned to one or more learners, with zero or more instructors.

This item type is available only in SLK (not in MLC).

AssignmentListForInstructors

Contains constants related to the AssignmentListForInstructors view.

Each row of this LearningStore view contains information about one assignment, as well as information about the e-learning package (if any) associated with the assignment. This view contains one row for each assignment for which the current user is an instructor.

This view is available only in SLK (not in MLC).

AssignmentPropertiesView

Contains constants related to the AssignmentPropertiesView view.

This LearningStore view contains information about one SLK assignment, as specified by the "AssignmentId" view parameter (the AssignmentItemIdentifier of an assignment) and the "IsInstructor" view parameter (true if the current user is an instructor on the assignment, false if they're a learner).

This view is available only in SLK (not in MLC).

AttemptItem

Contains constants related to the AttemptItem item type.

Each item contains information about one attempt, i.e. one instance of one learner executing one organization of one e-learning package. If the same learner attempts the same organization twice, two AttemptItem rows are created.

This LearningStore item type is available in both SLK and MLC. SLK extends this item type by adding the LearnerAssignmentId property/column and a SQL index.

AttemptObjectiveItem

Contains constants related to the AttemptObjectiveItem item type.

Each item contains information about the learner's progress on one local objective for one activity of one attempt.

This LearningStore item type is available in both SLK and MLC.

CommentFromLearnerItem

Contains constants related to the CommentFromLearnerItem item type.

Each item contains one comment from the learner related to one activity of one attempt.

This LearningStore item type is available in both SLK and MLC.

CommentFromLmsItem

Contains constants related to the CommentFromLmsItem item type.

Each item contains a "comments from LMS" string related to a specific activity within an e-learning package. These are read-only by SCOs. SLK does not add rows to the CommentsFromLmsItem table.

This LearningStore item type is available in both SLK and MLC.

CompleteLearnerAssignmentRight

Contains constants related to the CompleteLearnerAssignmentRight right.

CorrectResponseItem

Contains constants related to the CorrectResponseItem item type.

Each item contains information about one SCORM correct response string for one InteractionItem. The CorrectResponseItem table contains one row in this table per correct response per interaction.

This LearningStore item type is available in both SLK and MLC.

CreateAttemptRight

Contains constants related to the CreateAttemptRight right.

DeleteAttemptRight

Contains constants related to the DeleteAttemptRight right.

EvaluationCommentItem

Contains constants related to the EvaluationCommentItem item type.

Each item contains a comment from an evaluator (i.e. an instructor grading a learner assignment) related to one InteractionItem. Only used for e-learning packages in Class Server format.

This LearningStore item type is available in both SLK and MLC.

ExecuteSessionRight

Contains constants related to the ExecuteSessionRight right.

ExtensionDataItem

Contains constants related to the ExtensionDataItem item type.

Each item contains one "extension" data model element. An "extension" data model element is a data model element whose name does not begin with "cmi." or "adl.".

This LearningStore item type is available in both SLK and MLC.

FinalizeLearnerAssignmentRight

Contains constants related to the FinalizeLearnerAssignmentRight right.

FinishLearnerAssignmentRight

Contains constants related to the FinishLearnerAssignmentRight right.

GlobalObjectiveItem

Contains constants related to the GlobalObjectiveItem item type.

Each item contains information about one global objective related to one organization of one e-learning package, or one global objective that's not constrained to any one organization of any package.

This LearningStore item type is available in both SLK and MLC.

InstructorAssignmentItem

Contains constants related to the InstructorAssignmentItem item type.

Each item of this LearningStore item type contains information about one instructor assignment, i.e. the mapping of one instructor to one assignment. For example, if an assignment has three instructors, there will be three InstructorAssignmentItem table rows associated with that assignment.

This item type is available only in SLK (not in MLC).

InstructorAssignmentListForInstructors

Contains constants related to the InstructorAssignmentListForInstructors view.

Each row of this LearningStore view contains information about one instructor assignment, as well as information about the e-learning package (if any) associated with the assignment. This view returns one row for each instructor on each assignment for which the current user is an instructor.

This view is available only in SLK (not in MLC).

InteractionItem

Contains constants related to the InteractionItem item type.

Each item contains information about one interaction within one activity of one attempt.

This LearningStore item type is available in both SLK and MLC.

InteractionObjectiveItem

Contains constants related to the InteractionObjectiveItem item type.

Each item relates one InteractionItem with one AttemptObjectiveItem.

This LearningStore item type is available in both SLK and MLC.

LearnerAssignmentItem

Contains constants related to the LearnerAssignmentItem item type.

Each item of this LearningStore item type contains information about one learner assignment, i.e. the mapping of one learner to one assignment. For example, if an assignment has 30 learners, there will be 30 LearnerAssignmentItem table rows associated with that assignment.

This item type is available only in SLK (not in MLC).

LearnerAssignmentListForInstructors

Contains constants related to the LearnerAssignmentListForInstructors view.

Each row of this LearningStore view contains information about one learner assignment, as well as information about the e-learning package (if any) associated with the assignment. This view returns one row for each learner on each assignment for which the current user is an instructor.

This view is available only in SLK (not in MLC).

LearnerAssignmentListForLearners

Contains constants related to the LearnerAssignmentListForLearners view.

Each row of this LearningStore view contains information about one learner assignment, as well as information about the e-learning package (if any) associated with the assignment. This view returns one row for each assignment for which the current user is a learner, excluding assignments which have not yet started.

This view is available only in SLK (not in MLC).

LearnerAssignmentView

Contains constants related to the LearnerAssignmentView view.

This LearningStore view contains specific information about all learner assignments. By default, access is granted to no users; consider using other views.

This view is available only in SLK (not in MLC).

LearnerGlobalObjectiveItem

Contains constants related to the LearnerGlobalObjectiveItem item type.

Each item contains information about the progress of one learner against a particular global objective, across all activities in all e-learning packages. These objectives may be global to a single package or global to the system -- the data in this table does not distinguish between these two cases.

This LearningStore item type is available in both SLK and MLC.

MapActivityObjectiveToGlobalObjectiveItem

Contains constants related to the MapActivityObjectiveToGlobalObjectiveItem item type.

Each item contains a mapping between an ActivityObjectiveItem and a GlobalObjectiveItem.

This LearningStore item type is available in both SLK and MLC.

PackageGlobalObjectiveItem

Contains constants related to the PackageGlobalObjectiveItem item type.

Each item contains information about progress on one global objective related to one organization.

This LearningStore item type is available in both SLK and MLC.

PackageItem

Contains constants related to the PackageItem item type.

Each item contains information about one e-learning package. Before a package can be attempted, a row referring to it must be added to this table. When that happens, detailed information about the package is added to other tables in the schema; for example, information about each activity is added to the ActivityPackageItem table. SLK extends this item type by adding the Warnings property/column.

This LearningStore item type is available in both SLK and MLC.

RandomAccessSessionRight

Contains constants related to the RandomAccessSessionRight right.

ReadPackageRight

Contains constants related to the ReadPackageRight right.

RemovePackageReferenceRight

Contains constants related to the RemovePackageReferenceRight right.

ResourceItem

Contains constants related to the ResourceItem item type.

Each item contains information about resources used in activities, including the XML of each <resource> element in the package.

This LearningStore item type is available in both SLK and MLC.

ReviewSessionRight

Contains constants related to the ReviewSessionRight right.

RubricItem

Contains constants related to the RubricItem item type.

Each item contains information about a rubric that is attached to an interaction.

This LearningStore item type is available in both SLK and MLC.

SeqNavActivityAttemptView

Contains constants related to the SeqNavActivityAttemptView view.

SeqNavActivityPackageView

Contains constants related to the SeqNavActivityPackageView view.

SeqNavActivityTreeView

Contains constants related to the SeqNavActivityTreeView view.

SeqNavAttemptCommentFromLearnerView

Contains constants related to the SeqNavAttemptCommentFromLearnerView view.

SeqNavAttemptCorrectResponseView

Contains constants related to the SeqNavAttemptCorrectResponseView view.

SeqNavAttemptEvaluationCommentLearnerView

Contains constants related to the SeqNavAttemptEvaluationCommentLearnerView view.

SeqNavAttemptExtensionDataView

Contains constants related to the SeqNavAttemptExtensionDataView view.

SeqNavAttemptInteractionExtensionDataView

Contains constants related to the SeqNavAttemptInteractionExtensionDataView view.

SeqNavAttemptInteractionObjectiveView

Contains constants related to the SeqNavAttemptInteractionObjectiveView view.

SeqNavAttemptInteractionView

Contains constants related to the SeqNavAttemptInteractionView view.

SeqNavAttemptObjectiveExtensionDataView

Contains constants related to the SeqNavAttemptObjectiveExtensionDataView view.

SeqNavAttemptObjectiveView

Contains constants related to the SeqNavAttemptObjectiveView view.

SeqNavAttemptRubricView

Contains constants related to the SeqNavAttemptRubricView view.

SeqNavAttemptView

Contains constants related to the SeqNavAttemptView view.

SeqNavCurrentActivityAttemptView

Contains constants related to the SeqNavCurrentActivityAttemptView view.

SeqNavCurrentCommentFromLmsView

Contains constants related to the SeqNavCurrentCommentFromLmsView view.

SeqNavLearnerGlobalObjectiveView

Contains constants related to the SeqNavLearnerGlobalObjectiveView view.

SeqNavOrganizationGlobalObjectiveView

Contains constants related to the SeqNavOrganizationGlobalObjectiveView view.

SequencingLogEntryItem

Contains constants related to the SequencingLogEntryItem item type.

Each item contains one sequencing log entry, related to one activity of one attempt, or related to an entire attempt. See StoredLearningSession.LoggingOptions.

This LearningStore item type is available in both SLK and MLC.

SiteSettingsItem

Contains constants related to the SiteSettingsItem item type.

Each item of this LearningStore item type contains the SLK Settings corresponding to a given SharePoint site collectino (SPSite).

This item type is available only in SLK (not in MLC).

StartAttemptOnLearnerAssignmentRight

Contains constants related to the StartAttemptOnLearnerAssignmentRight right.

UserItem

Contains constants related to the UserItem item type.

Each item contains information about one user, including a numeric identifier (UserItemIdentifier) used elsewhere in the database to refer to the user. UserItem items contain a Key property (database column) which, for SLK, contains either the security ID (SID) of the user or the user's login name. (The login name is used for authentication mechanisms such as forms-based authentication which don't use security IDs.)

This LearningStore item type is available in both SLK and MLC. SLK extends this item type by granting access to all users.

UserWebList

Contains constants related to the UserWebList view.

Each row of this LearningStore view represents one entry in one user's "user Web list", for one site collection. A user Web list is the list of Web sites that appears on the SLK E-Learning Actions page for all document libraries within a given site collection. Each user has at most one user Web list for each site collection (SPSite).

This view is available only in SLK (not in MLC).

UserWebListItem

Contains constants related to the UserWebListItem item type.

Each item of this LearningStore item type represents one entry in one user's user Web list, for one site collection. A user Web list is the list of Web sites that appears on the SLK E-Learning Actions page for all document libraries within a given site collection. Each user has at most one user Web list for each site collection (SPSite).

This item type is available only in SLK (not in MLC).